Home/Database/Introduction to SQL

Introduction to SQL MCQs

73 questionsDatabasePage 5 of 9

Practice free Introduction to SQL multiple-choice questions with instant answer feedback and step-by-step solutions. Click an option to check yourself, reveal the full explanation, and work through all 73 questions — no login required.

Question 37easy
SQL provides the AS keyword, which can be used to assign meaningful column names to the results of queries using the SQL built-in functions.
Question 38easy
The SELECT command, with its various clauses, allows users to query the data contained in the tables and ask many different questions or ad hoc queries.
Question 39easy
A SELECT statement within another SELECT statement and enclosed in square brackets ([...]) is called a subquery.
Advertisement
Question 40easy
The rows of the result relation produced by a SELECT statement can be sorted, but only by one column.
Question 41easy
There is an equivalent join expression that can be substituted for all subquery expressions.
Question 42easy
A dynamic view is one whose contents materialize when referenced.
Advertisement
Question 43easy
SQL is a programming language.
Question 44easy
SELECT DISTINCT is used if a user wishes to see duplicate columns in a query.
Question 45easy
Indexes can usually be created for both primary and secondary keys.